package cn.wolfcode.crm.mapper;

import cn.wolfcode.crm.domain.ProductStock;
import cn.wolfcode.crm.query.QueryObject;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface ProductStockMapper {

    int insert(ProductStock record);

    int updateByPrimaryKey(ProductStock record);

    //分页查询
    int selectCount(QueryObject qo);

    List<ProductStock> queryForList(QueryObject qo);

    ProductStock selectByPrimaryKey (@Param("productId") Long productId, @Param("depotId") Long depotId);

    ProductStock selectByProductAndDepot(@Param("productId") Long id,@Param("depotId") Long id1);

    ProductStock selectStockByprotIdAndDepotId(@Param("productId") Long id,@Param("depotId") Long id1);

    Integer getLow();
}